<?php 
 require_once('inc_admin.php');

  connect();
 $sql = 'select * from flower';
  if($_POST['key'])  {
    $key = trim($_POST['key']);
    $sql = $sql." where zqy_title like '%{$key}%' ";
  }

  //echo $sql.'<br/>';  
  $result = fetch_array($sql); 
 ?>
 <center><h3>鲜花查找</h3></center>
 <table align="center" width="80%">
 <tr><td  align="left" >
 <form method=post action="">
    请输入鲜花名：
  <input type="text" name="key">
  <input type="submit" name='search' value="搜索">  
 </form> 
 </td></tr>
 </table>